For instance, if I create a new workspace named MyWorkspace1 which uses a database for the repository, Studio successfully creates the database tables and workspace. But if I then create another workspace, which also uses a database for the repository, and I name that workspace MyWorkspace2, when generating the database tables for MyWorkspace2, Studio displays this message:
Permission Error; check errors listed. Setup may require DBA assistance and Generated DDL statements.
Answer: This error occurs because the first eight characters in the workspace names are not unique. While you are not required to use Studio’s default table names, it tries to generate these default table names based on the workspace name you entered. You can either change the workspace name or you can change the library table names.
© Copyright 2017, Oracle and/or its affiliates. All rights reserved. Legal notices.